import pandas as pd
import pymysql
# import pymssql

config_mssql = {
          'host': '192.168.1.253',
          'port': 1433,
          'user': 'BS-Prt',
          'password': '123123',
          'database': 'BSPRODUCTCENTER',
          'charset': 'utf8'
}
# 连接sql-server
# conn = pymssql.connect(**config)

config = {
          'host': '192.168.3.172',
          'port': 3306,
          'user': 'django',
          'password': 'Abc123',
          'db': 'TEST',
          'charset': 'utf8mb4',
          'cursorclass': pymysql.cursors.DictCursor,
          }


connection = pymysql.connect(**config)

# 在服务中连接和关闭 connection.close()

